/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package DAO;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;

/**
 *
 * @author TAN
 */
public class ThongKeDAO {
   private Connect connect=null;

   public ThongKeDAO(String User ,String Pass,String port,String DataBase,String Host) {
        connect =new Connect( User , Pass, port, DataBase, Host);
    }
    
    public CallableStatement ThongTinThongKe()
    {   
       CallableStatement cals=null;
       Connection conn=connect.GetConnect();
        try
        {
            cals=conn.prepareCall("{call sp_ThongKeLoiNhuan(?,?,?)}"); 
            
        }
        catch(Exception e)
        {
          
        }
        return cals;
    }
    
    public void CloseConnect()
      {
          try
          {
          connect.Close();
          }catch(Exception e)
          {
              ;
          }
      }
}
